{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Drop down lists","Master"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[0,0,0,10],[1,0,1,10],[3,0,3,7],[6,2,6,7],[6,8,6,10],[17,0,17,2],[17,3,17,6],[17,7,17,10],[15,0,15,2],[15,3,15,6],[15,7,15,10],[2,6,2,7],[10,10,14,10],[16,0,16,2],[16,3,16,6],[16,7,16,10],[8,0,9,0],[8,1,8,2],[8,3,8,6],[8,7,8,10],[10,4,14,4],[10,7,14,7],[10,8,14,8],[10,9,14,9]]}
["HEALTHPRIME CONNECT"]
["Benefit Illustration in respect of policies offered on individual and family floater basis"]
["Plan","Essential","Sum Insured",2500000,"Policy Tenure","2 years"]
["Otional Covers"]
["Cumulative Bonus Enhancer","NA","OPD Cover","NA","Critical Illness & Personal Accident","NA","WorldWide Coverage","NA"]
["1st Adult Age",65,"2nd Adult Age",55,"1st Child Age",25,"2nd Child Age",20]
["3rd Child Age","3-11 Months",{"$f":"IF(OR(F5=\"No\",F5=\"NA\",F5=\"Please Select\"),\"\",IF(OR(B3=\"OptimumPlus\",B3=\"Essential\"),\"\",IF(AND(B3=\"Optimum\",D3<=2000000,OR(F5=\"CI: 2Lakhs & PA: 100% CSI\",F5=\"CI: 2Lakhs & PA: 150% CSI\")),\"\",IF(AND(B3=\"Optimum\",D3>=2500000,OR(F5=\"CI: 5Lakhs & PA: 100% CSI\",F5=\"CI: 5Lakhs & PA: 150% CSI\")),\"\",\"Kindly select correct Critical Illness & Personal Accident option from dropdown\"))))","v":""},null,null,null,null,null,"UIN: LIBHLIP21505V022021"]
[]
["Age of the members insured","Coverage opted on individual basis covering each member of the family separately (at a single point in time)",null,"Coverage opted on individual basis covering multiple members of the family under a single policy (Sum insured is available for each member of the family)",null,null,null,"Coverage opted on family floater basis with overall Sum insured (Only one sum insured is available for the entire family)"]
[null,"Premium (Rs.)","Sum insured (Rs.)","Premium (Rs.)","Discount, (if any)","Premium after discount (Rs.)","Sum insured (Rs.)","Premium or consolidated premium for all members of family (Rs.)","Floater discount, if any","Premium after discount (Rs.)","Sum insured"]
[{"$f":"B6","v":65},{"$f":"Master!AJ4","v":99026},{"$f":"IF(B6=\"\",0,$D$3)","v":2500000},{"$f":"Master!AJ4","v":99026},{"$f":"IF(AND(COUNT(Master!W4:W8)>2,Sheet1!F3=\"1 year\"),\"Family Discount: 10%\",IF(AND(COUNT(Master!W4:W8)>2,Sheet1!F3=\"2 years\"),\"Family Discount: 10% & Long Term Discount: 7.5%\",IF(AND(COUNT(Master!W4:W8)<=2,Sheet1!F3=\"2 years\"),\"Long Term Discount: 7.5%\",0%)))","v":"Family Discount: 10% & Long Term Discount: 7.5%"},{"$f":"Master!AL4","v":81696.45},{"$f":"IF(B6=\"\",0,$D$3)","v":2500000},{"$f":"IF(Master!$V$4=\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\",\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\",\"Base Plan Rs.\"&\" \"&ROUND(Master!AO4,0)&\"                                                                \"&\"Optional Cover Rs.\"&ROUND(Master!AO5,0))","v":"Base Plan Rs. 183511                                                                Optional Cover Rs.0"},{"$f":"IF(Master!$V$4=\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\",0%,Master!AG23)","v":0.4},{"$f":"IF(Master!$V$4=\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\",0,Master!AQ4)","v":110106},{"$f":"IF(Master!$V$4=\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\",0,Sheet1!D3)","v":2500000}]
[{"$f":"D6","v":55},{"$f":"Master!AJ5","v":58072},{"$f":"IF(D6=\"\",0,$D$3)","v":2500000},{"$f":"Master!AJ5","v":58072},null,{"$f":"Master!AL5","v":47909.399999999994},{"$f":"IF(D6=\"\",0,$D$3)","v":2500000}]
[{"$f":"F6","v":25},{"$f":"Master!AJ6","v":13764},{"$f":"IF(F6=\"\",0,$D$3)","v":2500000},{"$f":"Master!AJ6","v":13764},null,{"$f":"Master!AL6","v":11355.3},{"$f":"IF(F6=\"\",0,$D$3)","v":2500000}]
[{"$f":"H6","v":20},{"$f":"Master!AJ7","v":13764},{"$f":"IF(H6=\"\",0,$D$3)","v":2500000},{"$f":"Master!AJ7","v":13764},null,{"$f":"Master!AL7","v":11355.3},{"$f":"IF(H6=\"\",0,$D$3)","v":2500000}]
[{"$f":"B7","v":"3-11 Months"},{"$f":"Master!AJ8","v":13764},{"$f":"IF(B7=\"\",0,$D$3)","v":2500000},{"$f":"Master!AJ8","v":13764},null,{"$f":"Master!AL8","v":11355.3},{"$f":"IF(B7=\"\",0,$D$3)","v":2500000}]
[{"$f":"Master!AN7","v":"Total Premium for all members of the family is, Rs. 183511 (excluding GST) when each member is covered separately."},null,null,{"$f":"Master!AO7","v":"Total Premium for all members of the family is, Rs. 163672 (excluding GST)  when they are covered under a single policy"},null,null,null,{"$f":"Master!AP7","v":"Total Premium when policy is opted on floater basis is, Rs. 110106 (excluding GST)"}]
[{"$f":"IF(F3=\"2 years\",\"*Total premium shown above includes long term discount\",\"\")","v":"*Total premium shown above includes long term discount"},null,null,"",null,null,null,{"$f":"IF(Master!$V$4=\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\",\"\",IF($F$3=\"1 year\",\"*Floater discount applies only to Base Plan premium\",\"*Floater discount applies only to Base Plan premium & consolidated premium shown above includes long term discount\"))","v":"*Floater discount applies only to Base Plan premium & consolidated premium shown above includes long term discount"}]
[{"$f":"Master!AN8","v":"Sum insured available for each individual is Rs. 2500000"},null,null,{"$f":"Master!AO8","v":"Sum insured available for each family member is Rs. 2500000"},null,null,null,{"$f":"Master!AP8","v":"Sum insured of Rs. 2500000 is available for the entire family."}]

{"sheet":"Drop down lists","index":1,"n_rows":67,"n_cols":21,"rows_kept":67,"cut":false,"hidden":true,"merged":[]}
["Plan","Sum Insured","Optimum upto 20L","Optimum Above 20L","OptimumPlus","OPDLimit","CBE & Worlwide","Essential Optional Cover","No. of Insured","No. of Children","Ind Relationship","Family Relationship",null,null,"Occupation","Loading","Loading","Gender","Nominee Relationship","Policy Tenure","Age"]
["Essential",1000000,"No","No","No","No","Yes","NA",1,0,null,null,null,null,"Salaried",0,"NA","Male","Self","1 year","3-11 Months"]
["Optimum",1500000,"CI: 2Lakhs & PA: 100% CSI","CI: 5Lakhs & PA: 100% CSI","CI: 5Lakhs & PA: 100% CSI",10000,"No",null,2,1,"Self","Self",null,"Self","Housewife",0.05,null,"Female","Spouse","2 years",1]
["OptimumPlus",2000000,"CI: 2Lakhs & PA: 150% CSI","CI: 5Lakhs & PA: 150% CSI","CI: 5Lakhs & PA: 150% CSI",15000,null,null,3,2,"Spouse","Spouse",null,"Spouse","Student",0.1,null,null,"Mother",null,2]
[null,2500000,null,null,"CI: 10Lakhs & PA: 100% CSI",20000,null,null,4,3,"Son","Son",null,"Mother","Retired",0.15,null,null,"Father",null,3]
[null,3000000,null,null,"CI: 10Lakhs & PA: 150% CSI",30000,null,null,5,4,"Daughter","Daughter",null,"Father","Others",0.2,null,null,"Others",null,4]
[null,5000000,null,null,null,null,null,null,null,null,"Mother","Mother",null,"Brother",null,0.25,null,null,null,null,5]
[null,7500000,null,null,null,null,null,null,null,null,"Father","Father",null,"Sister",null,0.3,null,null,null,null,6]
[null,10000000,null,null,null,null,null,null,null,null,"Brother","Mother-in-Law",null,"Mother-in-Law",null,0.35,null,null,null,null,7]
[null,null,null,null,null,null,null,null,null,null,"Sister","Father-in-law",null,"Father-in-law",null,0.4,null,null,null,null,8]
[null,null,null,null,null,null,null,null,null,null,"Mother-in-Law",null,null,"Son-in-law",null,0.45,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,null,"Father-in-law",null,null,"Daughter-in-law",null,0.5,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,null,"Son-in-law",null,null,"Grand-Mother",null,0.6,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,null,"Daughter-in-law",null,null,"Grand-Father",null,0.7,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,null,"Grand-Son",null,null,null,null,0.8,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,null,"Grand-Daughter",null,null,null,null,0.9,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,null,"Grand-Mother",null,null,null,null,1,null,null,null,null,15]
[null,null,null,null,null,null,null,null,null,null,"Grand-Father",null,null,null,null,null,null,null,null,null,16]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,26]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,31]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,32]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,34]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,36]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,38]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,41]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,43]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,44]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,45]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,46]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,47]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,49]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,50]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,51]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,52]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,54]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,55]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,56]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,57]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,58]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,59]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,60]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,61]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,62]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,65]

{"sheet":"Master","index":2,"n_rows":108,"n_cols":44,"rows_kept":108,"cut":false,"hidden":true,"merged":[[39,1,39,6],[12,26,12,27],[12,38,12,39],[3,21,7,21]]}
[]
["Essential",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Working"]
["Age Band","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years",null,null,null,"Age Band",null,{"$f":"AB3","v":"Base Premium"},null,null,null,"Floater Combination","Insured Name","Age","Age band","Sum insured","Match","Base Premium","Maternity Age Band","Maternity Cover","Family Floater Discount","Critical Illness & Personal Accident Cover","OPD Cover","Cumultive Bonus Enhancer","Worldwide Coverage","Total","Ind prm with long term discount","Ind prm with family+Long term discount",null,"Floater premium","Floater premium with long term discount","Prm with Floater Discount","Final Floater Premium"]
[1000000,5191,7323,9624,12724,16218,21090,26362,34286,47876,60409,82086,null,0.25,25,"91 days - 25 years",null,"1 year","2 years","3 years",null,{"$f":"IF(AND(SUM($W$4:$W$5)=1,SUM($W$6:$W$8)=1),\"1A1C\",IF(AND(SUM($W$4:$W$5)=1,SUM($W$6:$W$8)=2),\"1A2C\",IF(AND(SUM($W$4:$W$5)=1,SUM($W$6:$W$8)=3),\"1A3C\",IF(AND(SUM($W$4:$W$5)=2,SUM($W$6:$W$8)=0),\"2A\",IF(AND(SUM($W$4:$W$5)=2,SUM($W$6:$W$8)=1),\"2A1C\",IF(AND(SUM($W$4:$W$5)=2,SUM($W$6:$W$8)=2),\"2A2C\",IF(AND(SUM($W$4:$W$5)=2,SUM($W$6:$W$8)=3),\"2A3C\",\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\")))))))","v":"2A3C"},{"$f":"IF(X4=\"\",\"\",1)","v":1},{"$f":"IF(Sheet1!B6=\"\",\"\",Sheet1!B6)","v":65},{"$f":"IFERROR(LOOKUP(X4,Master!$N$4:$P$14),0)","v":"61 years - 65 years"},{"$f":"IF(X4=\"\",\"\",Sheet1!$D$3)","v":2500000},{"$f":"IF(X4=\"\",\"\",Sheet1!$B$3&Sheet1!$D$3)","v":"Essential2500000"},{"$f":"IFERROR(IF(Sheet1!$F$3=Master!$R$4,Master!R5,(IF(Sheet1!$F$3=Master!$S$4,Master!S5,(IF(Sheet1!$F$3=Master!$T$4,Master!T5,0))))),0)","v":99026},{"$f":"IFERROR(LOOKUP(X4,Master!$N$17:$P$28),0)","v":"61 years - 65 years"},{"$f":"IFERROR(IF(OR(Sheet1!$B$3=\"Essential\",Master!$V$4=\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\"),0,IF(Sheet1!$F$3=\"1 year\",Master!M31,Master!N31)),0)","v":0},null,{"$f":"IFERROR(IF(OR(Sheet1!$F$5=\"No\",Sheet1!$F$5=\"NA\",Sheet1!$F$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",INDEX($M$52:$X$58,MATCH(Sheet1!$F$5,Master!$M$52:$M$58,0),MATCH(Master!Y4,Master!$M$52:$X$52,0)),INDEX($M$60:$X$66,MATCH(Sheet1!$F$5,Master!$M$60:$M$66,0),MATCH(Master!Y4,Master!$M$60:$X$60,0)))),0)","v":0},{"$f":"IFERROR(IF(OR(Sheet1!$D$5=\"No\",Sheet1!$D$5=\"NA\",Sheet1!$D$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",Master!M102,IF(Sheet1!$F$3=\"2 years\",Master!N102,0))),0)","v":0},{"$f":"IFERROR(IF(Sheet1!$B$5=\"Yes\",AK23,0),0)","v":0},{"$f":"IFERROR(IF(OR(Sheet1!$H$5=\"No\",Sheet1!$H$5=\"NA\",Sheet1!$H$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",Master!Z88,Master!AA88)),0)","v":0},{"$f":"AB4+AF4+AG4+AH4+AI4","v":99026},{"$f":"IF(Sheet1!$F$3=\"2 years\",Master!AJ4*92.5%,Master!AJ4)","v":91599.05},{"$f":"IF(AND(COUNT($W$4:$W$8)>2,Sheet1!$F$3=\"2 years\"),Master!AJ4*82.5%,IF(AND(COUNT($W$4:$W$8)>2,Sheet1!$F$3=\"1 year\"),Master!AJ4*90%,IF(AND(COUNT($W$4:$W$8)<=2,Sheet1!$F$3=\"2 years\"),Master!AJ4*92.5%,Master!AJ4)))","v":81696.45},"Base Premium",{"$f":"AB10+AD10","v":198390},{"$f":"IF(Sheet1!$F$3=\"2 years\",Master!AN4*92.5%,Master!AN4)","v":183510.75},{"$f":"AO4*(100%-AG23)","v":110106.45},{"$f":"IF($V$4=\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\",0,ROUND(SUM(AP4:AP5),0))","v":110106}]
[1500000,5945,8531,11194,14784,18844,24481,30961,40735,57939,74888,102508,null,26,35,"26 years - 35 years",null,{"$f":"IFERROR(INDEX($M$36:$X$50,MATCH(AA4,$M$36:$M$50,0),MATCH(Y4,$M$36:$X$36,0)),0)","v":49513},{"$f":"R5*$S$12","v":99026},{"$f":"R5*$T$12","v":148539},null,null,{"$f":"IF(X5=\"\",\"\",1)","v":1},{"$f":"IF(Sheet1!D6=\"\",\"\",Sheet1!D6)","v":55},{"$f":"IFERROR(LOOKUP(X5,Master!$N$4:$P$14),0)","v":"51 years - 55 years"},{"$f":"IF(X5=\"\",\"\",Sheet1!$D$3)","v":2500000},{"$f":"IF(X5=\"\",\"\",Sheet1!$B$3&Sheet1!$D$3)","v":"Essential2500000"},{"$f":"IFERROR(IF(Sheet1!$F$3=Master!$R$4,Master!R6,(IF(Sheet1!$F$3=Master!$S$4,Master!S6,(IF(Sheet1!$F$3=Master!$T$4,Master!T6,0))))),0)","v":58072},{"$f":"IFERROR(LOOKUP(X5,Master!$N$17:$P$28),0)","v":"51 years - 55 years"},{"$f":"IFERROR(IF(OR(Sheet1!$B$3=\"Essential\",Master!$V$4=\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\"),0,IF(Sheet1!$F$3=\"1 year\",Master!M32,Master!N32)),0)","v":0},null,{"$f":"IFERROR(IF(OR(Sheet1!$F$5=\"No\",Sheet1!$F$5=\"NA\",Sheet1!$F$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",INDEX($M$52:$X$58,MATCH(Sheet1!$F$5,Master!$M$52:$M$58,0),MATCH(Master!Y5,Master!$M$52:$X$52,0)),INDEX($M$60:$X$66,MATCH(Sheet1!$F$5,Master!$M$60:$M$66,0),MATCH(Master!Y5,Master!$M$60:$X$60,0)))),0)","v":0},{"$f":"IFERROR(IF(OR(Sheet1!$D$5=\"No\",Sheet1!$D$5=\"NA\",Sheet1!$D$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",Master!M103,IF(Sheet1!$F$3=\"2 years\",Master!N103,0))),0)","v":0},{"$f":"IFERROR(IF(Sheet1!$B$5=\"Yes\",AK24,0),0)","v":0},{"$f":"IFERROR(IF(OR(Sheet1!$H$5=\"No\",Sheet1!$H$5=\"NA\",Sheet1!$H$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",Master!Z89,Master!AA89)),0)","v":0},{"$f":"AB5+AF5+AG5+AH5+AI5","v":58072},{"$f":"IF(Sheet1!$F$3=\"2 years\",Master!AJ5*92.5%,Master!AJ5)","v":53716.600000000006},{"$f":"IF(AND(COUNT($W$4:$W$8)>2,Sheet1!$F$3=\"2 years\"),Master!AJ5*82.5%,IF(AND(COUNT($W$4:$W$8)>2,Sheet1!$F$3=\"1 year\"),Master!AJ5*90%,IF(AND(COUNT($W$4:$W$8)<=2,Sheet1!$F$3=\"2 years\"),Master!AJ5*92.5%,Master!AJ5)))","v":47909.399999999994},"Optional Cover",{"$f":"AG11","v":0},{"$f":"IF(Sheet1!$F$3=\"2 years\",Master!AN5*92.5%,Master!AN5)","v":0},{"$f":"AO5","v":0}]
[2000000,6405,9294,12205,16110,20533,26719,33996,44991,64837,84754,116667,null,36,40,"36 years - 40 years",null,{"$f":"IFERROR(INDEX($M$36:$X$50,MATCH(AA5,$M$36:$M$50,0),MATCH(Y5,$M$36:$X$36,0)),0)","v":29036},{"$f":"R6*$S$12","v":58072},{"$f":"R6*$T$12","v":87108},null,null,1,{"$f":"IF(Sheet1!F6=\"\",\"\",IF(Sheet1!F6=\"3-11 Months\",0.25,Sheet1!F6))","v":25},{"$f":"IFERROR(LOOKUP(X6,Master!$N$4:$P$14),0)","v":"91 days - 25 years"},{"$f":"IF(X6=\"\",\"\",Sheet1!$D$3)","v":2500000},{"$f":"IF(X6=\"\",\"\",Sheet1!$B$3&Sheet1!$D$3)","v":"Essential2500000"},{"$f":"IFERROR(IF(Sheet1!$F$3=Master!$R$4,Master!R7,(IF(Sheet1!$F$3=Master!$S$4,Master!S7,(IF(Sheet1!$F$3=Master!$T$4,Master!T7,0))))),0)","v":13764},{"$f":"IFERROR(LOOKUP(X6,Master!$N$17:$P$28),0)","v":"18 years - 25 years"},{"$f":"IFERROR(IF(OR(Sheet1!$B$3=\"Essential\",Master!$V$4=\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\"),0,IF(Sheet1!$F$3=\"1 year\",Master!M33,Master!N33)),0)","v":0},null,{"$f":"IFERROR(IF(OR(Sheet1!$F$5=\"No\",Sheet1!$F$5=\"NA\",Sheet1!$F$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",INDEX($M$52:$X$58,MATCH(Sheet1!$F$5,Master!$M$52:$M$58,0),MATCH(Master!Y6,Master!$M$52:$X$52,0)),INDEX($M$60:$X$66,MATCH(Sheet1!$F$5,Master!$M$60:$M$66,0),MATCH(Master!Y6,Master!$M$60:$X$60,0)))),0)","v":0},{"$f":"IFERROR(IF(OR(Sheet1!$D$5=\"No\",Sheet1!$D$5=\"NA\",Sheet1!$D$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",Master!M104,IF(Sheet1!$F$3=\"2 years\",Master!N104,0))),0)","v":0},{"$f":"IFERROR(IF(Sheet1!$B$5=\"Yes\",AK25,0),0)","v":0},{"$f":"IFERROR(IF(OR(Sheet1!$H$5=\"No\",Sheet1!$H$5=\"NA\",Sheet1!$H$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",Master!Z90,Master!AA90)),0)","v":0},13764,{"$f":"IF(Sheet1!$F$3=\"2 years\",Master!AJ6*92.5%,Master!AJ6)","v":12731.7},{"$f":"IF(AND(COUNT($W$4:$W$8)>2,Sheet1!$F$3=\"2 years\"),Master!AJ6*82.5%,IF(AND(COUNT($W$4:$W$8)>2,Sheet1!$F$3=\"1 year\"),Master!AJ6*90%,IF(AND(COUNT($W$4:$W$8)<=2,Sheet1!$F$3=\"2 years\"),Master!AJ6*92.5%,Master!AJ6)))","v":11355.3}]
[2500000,6882,10085,13250,17482,22281,29036,37134,49513,72130,95145,131559,null,41,45,"41 years - 45 years",null,{"$f":"IFERROR(INDEX($M$36:$X$50,MATCH(AA6,$M$36:$M$50,0),MATCH(Y6,$M$36:$X$36,0)),0)","v":6882},13764,20646,null,null,1,{"$f":"IF(Sheet1!H6=\"\",\"\",IF(Sheet1!H6=\"3-11 Months\",0.25,Sheet1!H6))","v":20},{"$f":"IFERROR(LOOKUP(X7,Master!$N$4:$P$14),0)","v":"91 days - 25 years"},{"$f":"IF(X7=\"\",\"\",Sheet1!$D$3)","v":2500000},{"$f":"IF(X7=\"\",\"\",Sheet1!$B$3&Sheet1!$D$3)","v":"Essential2500000"},{"$f":"IFERROR(IF(Sheet1!$F$3=Master!$R$4,Master!R8,(IF(Sheet1!$F$3=Master!$S$4,Master!S8,(IF(Sheet1!$F$3=Master!$T$4,Master!T8,0))))),0)","v":13764},{"$f":"IFERROR(LOOKUP(X7,Master!$N$17:$P$28),0)","v":"18 years - 25 years"},{"$f":"IFERROR(IF(OR(Sheet1!$B$3=\"Essential\",Master!$V$4=\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\"),0,IF(Sheet1!$F$3=\"1 year\",Master!M34,Master!N34)),0)","v":0},null,{"$f":"IFERROR(IF(OR(Sheet1!$F$5=\"No\",Sheet1!$F$5=\"NA\",Sheet1!$F$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",INDEX($M$52:$X$58,MATCH(Sheet1!$F$5,Master!$M$52:$M$58,0),MATCH(Master!Y7,Master!$M$52:$X$52,0)),INDEX($M$60:$X$66,MATCH(Sheet1!$F$5,Master!$M$60:$M$66,0),MATCH(Master!Y7,Master!$M$60:$X$60,0)))),0)","v":0},{"$f":"IFERROR(IF(OR(Sheet1!$D$5=\"No\",Sheet1!$D$5=\"NA\",Sheet1!$D$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",Master!M105,IF(Sheet1!$F$3=\"2 years\",Master!N105,0))),0)","v":0},{"$f":"IFERROR(IF(Sheet1!$B$5=\"Yes\",AK26,0),0)","v":0},{"$f":"IFERROR(IF(OR(Sheet1!$H$5=\"No\",Sheet1!$H$5=\"NA\",Sheet1!$H$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",Master!Z91,Master!AA91)),0)","v":0},13764,{"$f":"IF(Sheet1!$F$3=\"2 years\",Master!AJ7*92.5%,Master!AJ7)","v":12731.7},{"$f":"IF(AND(COUNT($W$4:$W$8)>2,Sheet1!$F$3=\"2 years\"),Master!AJ7*82.5%,IF(AND(COUNT($W$4:$W$8)>2,Sheet1!$F$3=\"1 year\"),Master!AJ7*90%,IF(AND(COUNT($W$4:$W$8)<=2,Sheet1!$F$3=\"2 years\"),Master!AJ7*92.5%,Master!AJ7)))","v":11355.3},null,{"$f":"\"Total Premium for all members of the family is, Rs.\"&\" \"&AK9&\" \"&\"(excluding GST) when each member is covered separately.\"","v":"Total Premium for all members of the family is, Rs. 183511 (excluding GST) when each member is covered separately."},{"$f":"\"Total Premium for all members of the family is, Rs.\"&\" \"&AL9&\" \"&\"(excluding GST)  when they are covered under a single policy\"","v":"Total Premium for all members of the family is, Rs. 163672 (excluding GST)  when they are covered under a single policy"},{"$f":"\"Total Premium when policy is opted on floater basis is, Rs.\"&\" \"&AQ4&\" \"&\"(excluding GST)\"","v":"Total Premium when policy is opted on floater basis is, Rs. 110106 (excluding GST)"}]
[3000000,7845,11181,14629,18568,23023,29816,39029,51097,74325,98125,135520,null,46,50,"46 years - 50 years",null,{"$f":"IFERROR(INDEX($M$36:$X$50,MATCH(AA7,$M$36:$M$50,0),MATCH(Y7,$M$36:$X$36,0)),0)","v":6882},13764,20646,null,null,1,{"$f":"IF(Sheet1!B7=\"\",\"\",IF(Sheet1!B7=\"3-11 Months\",0.25,Sheet1!B7))","v":0.25},{"$f":"IFERROR(LOOKUP(X8,Master!$N$4:$P$14),0)","v":"91 days - 25 years"},{"$f":"IF(X8=\"\",\"\",Sheet1!$D$3)","v":2500000},{"$f":"IF(X8=\"\",\"\",Sheet1!$B$3&Sheet1!$D$3)","v":"Essential2500000"},{"$f":"IFERROR(IF(Sheet1!$F$3=Master!$R$4,Master!R9,(IF(Sheet1!$F$3=Master!$S$4,Master!S9,(IF(Sheet1!$F$3=Master!$T$4,Master!T9,0))))),0)","v":13764},{"$f":"IFERROR(LOOKUP(X8,Master!$N$17:$P$28),0)","v":"0 years - 17 years"},{"$f":"IFERROR(IF(OR(Sheet1!$B$3=\"Essential\",Master!$V$4=\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\"),0,IF(Sheet1!$F$3=\"1 year\",Master!M35,Master!N35)),0)","v":0},null,{"$f":"IFERROR(IF(OR(Sheet1!$F$5=\"No\",Sheet1!$F$5=\"NA\",Sheet1!$F$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",INDEX($M$52:$X$58,MATCH(Sheet1!$F$5,Master!$M$52:$M$58,0),MATCH(Master!Y8,Master!$M$52:$X$52,0)),INDEX($M$60:$X$66,MATCH(Sheet1!$F$5,Master!$M$60:$M$66,0),MATCH(Master!Y8,Master!$M$60:$X$60,0)))),0)","v":0},{"$f":"IFERROR(IF(OR(Sheet1!$D$5=\"No\",Sheet1!$D$5=\"NA\",Sheet1!$D$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",Master!M106,IF(Sheet1!$F$3=\"2 years\",Master!N106,0))),0)","v":0},{"$f":"IFERROR(IF(Sheet1!$B$5=\"Yes\",AK27,0),0)","v":0},{"$f":"IFERROR(IF(OR(Sheet1!$H$5=\"No\",Sheet1!$H$5=\"NA\",Sheet1!$H$5=\"Please Select\"),0,IF(Sheet1!$F$3=\"1 year\",Master!Z92,Master!AA92)),0)","v":0},13764,{"$f":"IF(Sheet1!$F$3=\"2 years\",Master!AJ8*92.5%,Master!AJ8)","v":12731.7},{"$f":"IF(AND(COUNT($W$4:$W$8)>2,Sheet1!$F$3=\"2 years\"),Master!AJ8*82.5%,IF(AND(COUNT($W$4:$W$8)>2,Sheet1!$F$3=\"1 year\"),Master!AJ8*90%,IF(AND(COUNT($W$4:$W$8)<=2,Sheet1!$F$3=\"2 years\"),Master!AJ8*92.5%,Master!AJ8)))","v":11355.3},null,{"$f":"\"Sum insured available for each individual is Rs.\"&\" \"&Sheet1!D3","v":"Sum insured available for each individual is Rs. 2500000"},{"$f":"\"Sum insured available for each family member is Rs.\"&\" \"&Sheet1!D3","v":"Sum insured available for each family member is Rs. 2500000"},{"$f":"IF($V$4=\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\",\"Sum insured of Rs.\"&\" \"&0&\" \"&\"is available for the entire family.\",\"Sum insured of Rs.\"&\" \"&Sheet1!D3&\" \"&\"is available for the entire family.\")","v":"Sum insured of Rs. 2500000 is available for the entire family."}]
[5000000,8573,12323,16063,21710,28039,38529,52315,71707,110916,154039,222865,null,51,55,"51 years - 55 years",null,{"$f":"IFERROR(INDEX($M$36:$X$50,MATCH(AA8,$M$36:$M$50,0),MATCH(Y8,$M$36:$X$36,0)),0)","v":6882},13764,20646,null,null,null,null,null,null,"Total (Individual)",{"$f":"SUM(AB4:AB8)","v":198390},null,null,null,{"$f":"SUM(AF4:AF8)","v":0},{"$f":"SUM(AG4:AG8)","v":0},{"$f":"SUM(AH4:AH8)","v":0},{"$f":"SUM(AI4:AI8)","v":0},198390,{"$f":"ROUND(SUM(AK4:AK8),0)","v":183511},{"$f":"ROUND(SUM(AL4:AL8),0)","v":163672}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,56,60,"56 years - 60 years",null,null,null,null,null,null,null,null,null,null,"Total (Family floater)",{"$f":"SUM(AB4:AB8)","v":198390},null,{"$f":"SUM(AD4:AD8)","v":0},{"$f":"-IF($V$4<>\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\",IF(COUNT(W4:W8)>1,Master!$AG$24,0),0)","v":-79356},{"$f":"SUM(AF4:AF8)","v":0},{"$f":"SUM(AG4:AG8)","v":0},{"$f":"IF(OR(Sheet1!$B$5=\"NA\",Sheet1!$B$5=\"No\"),0,AK21)","v":0},{"$f":"SUM(AI4:AI8)","v":0},{"$f":"SUM(AB10:AI10)","v":119034}]
["Optimum",null,null,null,null,null,null,null,null,null,null,null,null,61,65,"61 years - 65 years","Months",12,{"$f":"R11*2","v":24},{"$f":"R11*3","v":36},null,null,null,null,null,null,null,null,null,null,null,"Optional cover floater premium",{"$f":"AF10+AG10+AH10+AI10","v":0}]
["Age Band","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years",null,66,70,"66 years - 70 years","Years",1,2,3]
[1000000,8432,11910,14004,17306,20756,26172,32579,42231,58581,74228,100455,null,71,75,"71 years - 75 years",null,null,null,null,null,null,null,null,null,null,"Family floater Disc",null,null,null,null,null,null,null,null,"Enhanced CB",null,null,null,null,null,{"$f":"IF($AL$9=AQ3,$AR$22,IF($AL$9=AP4,AK9,IF($AL$9=AP5,AK9,IF($AL$9=AP6,AK9,IF($AL$9=AP7,$AR$22,IF($AL$9=AP8,AK10,IF($AL$9=AP9,AK10,IF($AL$9=AP10,AK10,0))))))))","v":0},"Very imp"]
[1500000,9297,13297,15806,19669,23768,30062,37854,49628,70125,90836,123881,null,76,100,"76 years - 100 years",null,"Reload Loading",200000,300000,400000,500000,750000,1000000,1500000,null,"Per child",0.1,null,null,null,null,null,null,null,"Plans","Loading"]
[2000000,9824,14172,16965,21189,25705,32629,41335,54510,78038,102152,140122,null,null,null,null,null,"91 days - 25 years",0.12,0.1,7.4999999999999997E-2,0.05,0.02,0.01,0.01,null,"For addition of 1 adult, the discount will be:",null,null,null,null,null,null,null,null,"Essential",0.05,null,null,null,null,"Basic Premium",null,{"$f":"IF(#REF!=\"Individual\",Master!$AJ$9,Master!$AJ$10)","v":{"$error":"#REF!"}}]
[2500000,10380,15089,18173,22773,27718,35293,44942,59717,86426,114102,157243,null,"Maternity Age band",null,null,null,"26 years - 35 years",0.15,0.12,0.1,0.05,0.02,0.01,0.01,null,"Age Bands","Discount",null,null,null,null,null,null,null,"Optimum",0.05,null,null,null,null,"Add:Substandard Risk loading",0]
[3000000,11319,16161,19552,23737,28365,35990,46756,61221,88594,117112,161315,null,0.17,17,"0 years - 17 years",null,"36 years - 40 years",0.15,0.12,0.1,0.05,0.02,0.01,0.01,null,"91 days - 25 years",0.25,null,null,null,null,null,null,null,"OptimumPlus",0.05,null,null,null,null,"Less:Family Discount",null,{"$f":"IF(AND(#REF!=\"Individual\",#REF!>2,COUNT(#REF!)=#REF!),(-(10%*Master!AR15)),0)","v":{"$error":"#REF!"}}]
[5000000,12127,17435,21162,27242,34018,45765,61775,84683,130388,181237,261494,null,18,25,"18 years - 25 years",null,"41 years - 45 years",0.2,0.15,0.12,7.4999999999999997E-2,0.05,0.02,0.02,null,"26 years - 35 years",0.25,null,null,null,"Adult",null,"Child",null,null,null,null,null,null,null,"Less:Employee Discount",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"-AR15*AQ18","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,26,35,"26 years - 35 years",null,"46 years - 50 years",0.2,0.15,0.12,0.1,0.05,0.02,0.02,null,"36 years - 40 years",0.25,null,null,null,"Highest Age",{"$f":"MAX($X$4:$X$8)","v":65},{"$f":"COUNTIFS($X$6:$X$8,\">=0.25\",$X$6:$X$8,\"<=25\",$X$6:$X$8,\"<=18\")","v":1},null,"For FF",null,null,null,null,null,"Less:Direct Policy Purchase Discount",0.1,{"$f":"IF(#REF!=\"Yes\",-(Master!$AQ$19*Master!$AR$15),0)","v":{"$error":"#REF!"}}]
["OptimumPlus",null,null,null,null,null,null,null,null,null,null,null,null,36,40,"36 years - 40 years",null,"51 years - 55 years",0.25,0.2,0.15,0.1,7.4999999999999997E-2,0.05,0.05,null,"41 years - 45 years",0.25,null,null,null,"Sum Insured",{"$f":"Z4","v":2500000},{"$f":"IF($AH$19=COUNT(W6:W8),\"Yes\",\"No\")","v":"No"},null,"Loading",{"$f":"IFERROR(VLOOKUP(Sheet1!$B$3,Master!$AJ$14:$AK$17,2,0),0)","v":0.05},null,null,null,null,"Less:Long term discount",null,{"$f":"IF(#REF!=\"2 years\",(-Master!$AB$31),IF(#REF!=\"3 years\",(-Master!$AE$31),0))","v":{"$error":"#REF!"}}]
["Age Band","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years",null,41,45,"41 years - 45 years",null,"56 years - 60 years",0.25,0.2,0.15,0.1,7.4999999999999997E-2,0.05,0.05,null,"46 years - 50 years",0.3,null,null,null,"Age band of Highest",{"$f":"LOOKUP($AG$19,$N$4:$P$14)","v":"61 years - 65 years"},null,null,"Loading Amt",{"$f":"$AK$20*($AB$10+$AD$10+$AE$10+$AI$10)","v":5951.7000000000007},null,null,null,null,"Substandard Loading",null,{"$f":"#REF!","v":{"$error":"#REF!"}}]
[7500000,14219,20980,24618,30877,38265,50809,68306,93504,143257,198738,285685,null,46,50,"46 years - 50 years",null,"61 years - 65 years",0.25,0.2,0.15,0.1,7.4999999999999997E-2,0.05,0.05,null,"51 years - 55 years",0.35,null,null,null,"Discount %",{"$f":"IF(COUNT(W4:W5)>1,VLOOKUP($AG$21,$AA$16:$AB$27,2,0),0)","v":0.35},{"$f":"COUNT(W6:W8)*10%","v":0.30000000000000004},null,"For Ind",null,null,null,null,null,"Net Premium wo installment",null,{"$f":"SUM(AR15:AR21)","v":{"$error":"#REF!"}}]
[10000000,14637,21674,25538,32051,39761,52792,70995,97286,149386,207503,298265,null,51,55,"51 years - 55 years",null,"66 years - 70 years",0.35,0.3,0.2,0.15,0.1,7.4999999999999997E-2,7.4999999999999997E-2,null,"56 years - 60 years",0.35,null,null,null,"Total disc",{"$f":"MIN(40%,SUM(AG22,AH22))","v":0.4},null,null,1,{"$f":"$AK$20*(AB4+AI4)","v":4951.3}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,56,60,"56 years - 60 years",null,"71 years - 75 years",0.4,0.35,0.25,0.2,0.15,0.1,0.1,null,"61 years - 65 years",0.35,null,null,null,"Total disc amt",{"$f":"$AG$23*($AB$10+$AD$10)","v":79356},null,null,2,{"$f":"$AK$20*(AB5+AI5)","v":2903.6000000000004}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,61,65,"61 years - 65 years",null,"76 years - 100 years",0.5,0.4,0.3,0.25,0.2,0.15,0.15,null,"66 years - 70 years",0.35,null,null,null,null,null,null,null,3,{"$f":"$AK$20*(AB6+AI6)","v":688.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,66,70,"66 years - 70 years",null,null,null,null,null,null,null,null,null,null,"71 years - 75 years",0.35,null,null,null,null,null,null,null,4,{"$f":"$AK$20*(AB7+AI7)","v":688.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,71,75,"71 years - 75 years",null,"Reload calc (Family Floater)",null,"Reload calc (Individual)",null,null,null,null,null,null,"76 years - 100 years",0.35,null,null,null,null,null,null,null,5,{"$f":"$AK$20*(AB8+AI8)","v":688.2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,76,100,"76 years - 100 years",null,"Loading %",{"$f":"VLOOKUP($AG$21,R14:Y25,MATCH($AG$20,$R$14:$Y$14,0),0)","v":{"$error":"#N/A"}},"Sr. No.","Loading %","Loading amt"]
["Maternity prize loading",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Loading amt",{"$f":"$S$28*SUM(AB10:AG10)","v":{"$error":"#N/A"}},{"$f":"V4","v":"2A3C"},{"$f":"IFERROR(VLOOKUP(Y4,$R$14:$Y$25,MATCH(Z4,$R$14:$Y$14,0),0),0)","v":0},{"$f":"U29*SUM(AB4:AG4)","v":0},null,null,null,null,"Multi Policy Year Discount"]
["Plan/Age band","18 years - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years","1 Year","2 years",null,null,null,null,null,{"$f":"V5","v":0},{"$f":"IFERROR(VLOOKUP(Y5,$R$14:$Y$25,MATCH(Z5,$R$14:$Y$14,0),0),0)","v":0},{"$f":"U30*SUM(AB5:AG5)","v":0},null,null,null,null,null,"2 years",null,null,"3 years"]
["Optimum",3178,6355,5296,3178,1059,0,0,0,0,0,0,{"$f":"IF(X4=\"\",0,IF(AND($V$4<>\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\",X4>17),INDEX($A$30:$L$32,MATCH(Sheet1!$B$3,$A$30:$A$32,0),MATCH(AC4,$A$30:$L$30,0)),0))","v":{"$error":"#N/A"}},{"$f":"M31*2","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"V6","v":0},0,0,null,null,null,null,"Disc amount",{"$f":"7.5%*#REF!","v":{"$error":"#REF!"}},null,null,{"$f":"10%*#REF!","v":{"$error":"#REF!"}},null,null,null,null,"Installment Calculation"]
["OptimumPlus",4609,9217,7681,4609,1536,0,0,0,0,0,0,{"$f":"IF(X5=\"\",0,IF(AND($V$4<>\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\",X5>17),INDEX($A$30:$L$32,MATCH(Sheet1!$B$3,$A$30:$A$32,0),MATCH(AC5,$A$30:$L$30,0)),0))","v":{"$error":"#N/A"}},{"$f":"M32*2","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"V7","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,"Installment Frequency","Loading on Annual Premium"]
[null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"M33*2","v":0},null,null,null,null,null,{"$f":"V8","v":0},0,0,null,null,null,null,null,null,null,null,null,null,"No",null,null,"No",0]
[null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"M34*2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Half_Yearly",null,null,"Half_Yearly",0.02]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(X8=\"\",0,IF(AND($V$4<>\"Available floater combinations - 1A1C, 1A2C, 1A3C, 2A, 2A1C, 2A2C or 2A3C\",X8>17),INDEX($A$30:$L$32,MATCH(Sheet1!$B$3,$A$30:$A$32,0),MATCH(AC8,$A$30:$L$30,0)),0))","v":0},{"$f":"M35*2","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Quarterly",null,null,"Quarterly",0.04]
[null,null,null,null,null,null,null,null,null,null,null,null,"Age band","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years",null,null,null,null,null,null,null,null,"Monthly",null,null,"Monthly",0.05]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$A$2&A4","v":"Essential1000000"},5191,7323,9624,12724,16218,21090,26362,34286,47876,60409,82086]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$A$2&A5","v":"Essential1500000"},5945,8531,11194,14784,18844,24481,30961,40735,57939,74888,102508,null,null,null,null,null,null,null,null,null,null,null,"Option Loading",{"$f":"IFERROR(VLOOKUP(#REF!,Master!$AJ$32:$AK$36,2,0),0)","v":0}]
[null,null,null,{"$f":"D32*2","v":15362},null,null,null,null,null,null,null,null,"Essential2000000",6405,9294,12205,16110,20533,26719,33996,44991,64837,84754,116667,null,null,null,null,null,null,null,null,null,null,null,null,"Loading amt","Premium with loading"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Essential2500000",6882,10085,13250,17482,22281,29036,37134,49513,72130,95145,131559,null,null,null,null,null,null,null,null,null,null,null,"Individual",{"$f":"$AK$38*$AR$22","v":{"$error":"#REF!"}},{"$f":"$AK$40+$AR$22","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Essential3000000",7845,11181,14629,18568,23023,29816,39029,51097,74325,98125,135520,null,null,null,null,null,null,null,null,null,null,null,"FF",{"$f":"$AK$38*$AR$22","v":{"$error":"#REF!"}},{"$f":"$AK$41+AR22","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Essential5000000",8573,12323,16063,21710,28039,38529,52315,71707,110916,154039,222865]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$A$11&A13","v":"Optimum1000000"},8432,11910,14004,17306,20756,26172,32579,42231,58581,74228,100455]
[null,null,null,null,null,null,null,null,null,null,null,null,"Optimum1500000",9297,13297,15806,19669,23768,30062,37854,49628,70125,90836,123881]
[null,null,null,null,null,null,null,null,null,null,null,null,"Optimum2000000",9824,14172,16965,21189,25705,32629,41335,54510,78038,102152,140122]
[null,null,null,null,null,null,null,null,null,null,null,null,"Optimum2500000",10380,15089,18173,22773,27718,35293,44942,59717,86426,114102,157243]
[null,null,null,null,null,null,null,null,null,null,null,null,"Optimum3000000",11319,16161,19552,23737,28365,35990,46756,61221,88594,117112,161315]
[null,null,null,null,null,null,null,null,null,null,null,null,"Optimum5000000",12127,17435,21162,27242,34018,45765,61775,84683,130388,181237,261494]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$A$20&A22","v":"OptimumPlus7500000"},14219,20980,24618,30877,38265,50809,68306,93504,143257,198738,285685]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$A$20&A23","v":"OptimumPlus10000000"},14637,21674,25538,32051,39761,52792,70995,97286,149386,207503,298265]
[]
["Optional Covers",null,null,null,null,null,null,null,null,null,null,null,"Option: 1 year","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years"]
["01. CI & PA Cover",null,null,null,null,null,null,null,null,null,null,null,"CI: 2Lakhs & PA: 100% CSI",674,827,1056,1920,3636,5666,9487,14380,22959,34396,34396]
[null,null,null,null,null,null,null,null,null,null,null,null,"CI: 2Lakhs & PA: 150% CSI",741,910,1162,2112,4000,6232,10435,15818,25255,37836,37836]
["200000 with PA @100%",null,null,null,null,null,null,null,null,null,null,null,"CI: 5Lakhs & PA: 100% CSI",1684,2068,2641,4801,9091,14164,23716,35950,57397,85990,85990]
["Policy Tenure/Age Band","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years","CI: 5Lakhs & PA: 150% CSI",1853,2275,2905,5281,10000,15581,26088,39545,63137,94590,94590]
["1 year",674,827,1056,1920,3636,5666,9487,14380,22959,34396,34396,"CI: 10Lakhs & PA: 100% CSI",3369,4137,5282,9601,18182,28328,47433,71900,114794,171981,171981]
["2 years",1404,1749,2302,4396,8048,12542,21035,31895,50941,76336,76336,"CI: 10Lakhs & PA: 150% CSI",3705,4550,5810,10561,20000,31161,52176,79090,126274,189179,189179]
[]
["200000 with PA @150%",null,null,null,null,null,null,null,null,null,null,null,"Option: 2 years","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years"]
["Policy Tenure/Age Band","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years","CI: 2Lakhs & PA: 100% CSI",1404,1749,2302,4396,8048,12542,21035,31895,50941,76336,76336,{"$f":"INDEX(M52:X58,MATCH(#REF!,Master!M52:M58,0),MATCH(Master!Y4,Master!M52:X52,0))","v":{"$error":"#REF!"}}]
["1 year",741,910,1162,2112,4000,6232,10435,15818,25255,37836,37836,"CI: 2Lakhs & PA: 150% CSI",1544,1924,2533,4835,8853,13796,23139,35084,56035,83969,83969]
["2 years",1544,1924,2533,4835,8853,13796,23139,35084,56035,83969,83969,"CI: 5Lakhs & PA: 100% CSI",3510,4372,5756,10989,20120,31354,52589,79737,127353,190839,190839]
[null,null,null,null,null,null,null,null,null,null,null,null,"CI: 5Lakhs & PA: 150% CSI",3860,4809,6332,12088,22133,34489,57848,87711,140088,209923,209923]
["500000 with PA @100%",null,null,null,null,null,null,null,null,null,null,null,"CI: 10Lakhs & PA: 100% CSI",7019,8744,11512,21978,40241,62708,105177,159475,254705,381679,381679]
["Policy Tenure/Age Band","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years","CI: 10Lakhs & PA: 150% CSI",7721,9618,12664,24175,44265,68979,115695,175422,280176,419847,419847]
["1 year",1684,2068,2641,4801,9091,14164,23716,35950,57397,85990,85990]
["2 years",3510,4372,5756,10989,20120,31354,52589,79737,127353,190839,190839]
[]
["500000 with PA @150%"]
["Policy Tenure/Age Band","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years"]
["1 year",1853,2275,2905,5281,10000,15581,26088,39545,63137,94590,94590]
["2 years",3860,4809,6332,12088,22133,34489,57848,87711,140088,209923,209923]
[]
["1000000 with PA @100%"]
["Policy Tenure/Age Band","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years"]
["1 year",3369,4137,5282,9601,18182,28328,47433,71900,114794,171981,171981]
["2 years",7019,8744,11512,21978,40241,62708,105177,159475,254705,381679,381679]
[]
["1000000 with PA @150%"]
["Policy Tenure/Age Band","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years"]
["1 year",3705,4550,5810,10561,20000,31161,52176,79090,126274,189179,189179]
["2 years",7721,9618,12664,24175,44265,68979,115695,175422,280176,419847,419847]
[]
["02. Worlwide Cover"]
["Optimum",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AI3","v":"Worldwide Coverage"}]
["Sum Insured/Age Bracket","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years",null,"Age Band","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years","1 year","2 years"]
[1000000,320,517,680,851,1085,1386,4029,5642,8507,11685,16384,null,{"$f":"$A$86&A88","v":"Optimum1000000"},320,517,680,851,1085,1386,4029,5642,8507,11685,16384,{"$f":"IFERROR(INDEX($N$87:$Y$95,MATCH(AA4,$N$87:$N$95,0),MATCH(Y4,$N$87:$Y$87,0)),0)","v":0},{"$f":"Z88*$S$12","v":0}]
[1500000,403,650,853,1068,1361,1743,5065,7094,10773,14945,20981,null,{"$f":"$A$86&A89","v":"Optimum1500000"},403,650,853,1068,1361,1743,5065,7094,10773,14945,20981,{"$f":"IFERROR(INDEX($N$87:$Y$95,MATCH(AA5,$N$87:$N$95,0),MATCH(Y5,$N$87:$Y$87,0)),0)","v":0},{"$f":"Z89*$S$12","v":0}]
[2000000,454,734,964,1208,1539,1978,5750,8052,12326,17165,24169,null,"Optimum2000000",454,734,964,1208,1539,1978,5750,8052,12326,17165,24169,{"$f":"IFERROR(INDEX($N$87:$Y$95,MATCH(AA6,$N$87:$N$95,0),MATCH(Y6,$N$87:$Y$87,0)),0)","v":0},{"$f":"Z90*$S$12","v":0}]
[2500000,721,1169,1537,1924,2452,3163,8578,12014,18505,25848,36475,null,"Optimum2500000",721,1169,1537,1924,2452,3163,8578,12014,18505,25848,36475,{"$f":"IFERROR(INDEX($N$87:$Y$95,MATCH(AA7,$N$87:$N$95,0),MATCH(Y7,$N$87:$Y$87,0)),0)","v":0},{"$f":"Z91*$S$12","v":0}]
[3000000,767,1246,1639,2052,2615,3378,9162,12831,19830,27743,39194,null,"Optimum3000000",767,1246,1639,2052,2615,3378,9162,12831,19830,27743,39194,{"$f":"IFERROR(INDEX($N$87:$Y$95,MATCH(AA8,$N$87:$N$95,0),MATCH(Y8,$N$87:$Y$87,0)),0)","v":0},{"$f":"Z92*$S$12","v":0}]
[5000000,854,1390,1830,2438,3295,4511,12864,18895,30891,45202,66480,null,"Optimum5000000",854,1390,1830,2438,3295,4511,12864,18895,30891,45202,66480]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$A$95&A97","v":"OptimumPlus7500000"},912,1486,1957,2597,3498,4780,13594,19917,32547,47570,69880,12,{"$f":"Z94*2","v":24}]
["OptimumPlus",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$A$95&A98","v":"OptimumPlus10000000"},970,1582,2084,2757,3702,5049,14323,20939,34203,49939,73280,1,2]
["Sum Insured/Age Bracket","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years"]
[7500000,912,1486,1957,2597,3498,4780,13594,19917,32547,47570,69880]
[10000000,970,1582,2084,2757,3702,5049,14323,20939,34203,49939,73280]
[]
["03. OPD Cover - Individual",null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG3","v":"OPD Cover"}]
["Sum Insured/Age Bracket","91 days - 25 years","26 years - 35 years","36 years - 40 years","41 years - 45 years","46 years - 50 years","51 years - 55 years","56 years - 60 years","61 years - 65 years","66 years - 70 years","71 years - 75 years","76 years - 100 years","1 year","2 years"]
[10000,5263,5263,5263,5263,6140,7018,8772,8772,8772,8772,8772,{"$f":"IFERROR(INDEX($A$101:$L$105,MATCH(Sheet1!$D$5,Master!$A$101:$A$105,0),MATCH(Master!Y4,Master!$A$101:$L$101,0)),0)","v":0},{"$f":"M102*$S$12","v":0}]
[15000,6579,6579,6579,6579,7895,9211,13158,13158,13158,13158,13158,{"$f":"IFERROR(INDEX($A$101:$L$105,MATCH(Sheet1!$D$5,Master!$A$101:$A$105,0),MATCH(Master!Y5,Master!$A$101:$L$101,0)),0)","v":0},{"$f":"M103*$S$12","v":0}]
[20000,8772,8772,8772,8772,8772,10526,17544,17544,17544,17544,17544,{"$f":"IFERROR(INDEX($A$101:$L$105,MATCH(Sheet1!$D$5,Master!$A$101:$A$105,0),MATCH(Master!Y6,Master!$A$101:$L$101,0)),0)","v":0},{"$f":"M104*$S$12","v":0}]
[30000,13158,13158,13158,13158,13158,15789,26316,26316,26316,26316,26316,{"$f":"IFERROR(INDEX($A$101:$L$105,MATCH(Sheet1!$D$5,Master!$A$101:$A$105,0),MATCH(Master!Y7,Master!$A$101:$L$101,0)),0)","v":0},{"$f":"M105*$S$12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(INDEX($A$101:$L$105,MATCH(Sheet1!$D$5,Master!$A$101:$A$105,0),MATCH(Master!Y8,Master!$A$101:$L$101,0)),0)","v":0},{"$f":"M106*$S$12","v":0}]
["04. Cumulative Bonus Enhancer",null,null,null,null,null,null,null,null,null,null,null,12,{"$f":"M107*2","v":24}]
["Loading of 5% on overall premium for all ages excluding premium of CI & PA and OPD",null,null,null,null,null,null,null,null,null,null,null,1,2]